ocr: TASK A TASK B LOCK MANAGER Waiting for Waiting for release of release ot RID2 2001 by RID4221 by TASK 8 TASK. A 1.Task A issues Select"from Employee, (1000 shared ocks set) 2.Task B iSSuGS Update employee set salary a salary1.1; (waits for Task a to release its shared locks) 3.Task A now issues Update employee set bonus llag =1;(Task, A now wats for the axclusive locks set by TASK B to release, unaware that lask. Ai iS waitng on its own locks) FIGURE 3. Database deadlocks (the perpetual embrace).
